﻿CREATE FUNCTION [dbo].[fn_CustomProcs]
(
)
RETURNS TABLE
AS
	RETURN (
	    SELECT p.[name] AS ProcedureName
	    FROM   sys.procedures p
	    WHERE  p.[name] NOT IN (SELECT ProcedureName
	                            FROM   dbo.fn_CRUDProcs())
	           AND p.[name] NOT IN (SELECT ProcedureName
	                                FROM   dbo.fn_UtilProcs())
	           AND p.[name] NOT LIKE 'aspnet_%'
	           AND p.[name] NOT LIKE 'cp_%'
	           AND p.[name] NOT LIKE 'sp_%'
	)